EVE Search - Yapeal PHP API library (revision 1207 branches/keys/)

All Channels

EVE Technology Lab

Yapeal PHP API library (revision 1207 branches/keys/)

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Author	Thread Statistics \| Show CCP posts - 1 post(s)
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 7	Posted - 2011.09.17 14:30:00 - [1] - Quote SectionAccount.php is missing a part of the query in the getSQLQuery function. The second query for a YAPEAL_REGISTERED_MODE of 'ignored' does not return either a RKActive or a RKMask field, the RKActive of which means that all rows will always be filtered by the function below that, ignoredFilter. I think it would be good to change this. In addition, I'm getting: Quote: [2011-09-17 14:24:00.718] NOTICE: SkillInTraining is an unknown API for section char File: /var/www/core/lib/yapeal/class/util/CachedInterval.php(93) [2011-09-17 14:24:52.871] NOTICE: Contracts is an unknown API for section char File: /var/www/core/lib/yapeal/class/util/CachedInterval.php(93) Nothing major, but it's odd :P [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images?
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 7	Posted - 2011.09.17 18:04:00 - [2] - Quote Actually I just updated to the latest trunk, though with the converted database of an older version, so I guess it might have something to do with that. Not giving problems of any kind though, I believe the tables are even updated even though the notices appear. [img]http://www.evemarketeer.com/player/sig/511049420[/img] Want images?
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 39	Posted - 2011.12.18 00:52:00 - [3] - Quote The reason I'm reluctant to upgrade yapeal, is that every time I do, it blows up in my face. Today was the database upgrade script. I'm running it from the command line, but it kept complaining about not being able to find the database password, which is logical, as there isn't any. It also seems to be trying to connect over a unix socket, which is never going to work, but I guess this has more to do with php than with yapeal, as it worked later. Now I'm not to worried about this, so I took a look at the script and modified it so that password is not required anymore. I run it again and am confronted with the following message: --- Failed to execute schema for util Failed to execute schema for util There were problems during processing please check any error messages from above and correct. --- I probably do not have to explain that this does not help at all What I would like to see is: - What sections is the script updating at the moment? - What queries is it going to execute? - What is the result of the queries, and the result per section? I've now added these things manually, but every time I update yapeal they are overwritten again. Hopefully adding yapeal as a repository instead of a folder will allow me to push some of these changes back to the community. EDIT: That said, while I'm bitching about Yapeal a lot, I'm very happy you made it, since even if it's mostly just a black box for me, once it's working, it's working perfectly . Developer/Creator of EVE Marketeer
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 42	Posted - 2011.12.23 16:07:00 - [4] - Quote Yapeal has a problem where the log directories for log4php are not relative to the script execution root. Which is annoying to say the least. As it differs from how it originally worked. Ok, no, I got it wrong. The config file has actually changed, and it meant that yapeal suddenly didn't work anymore, because I was using the old config file (and the new config file still doesn't count log directories relative to the script execution directory). I just hope that this doesn't catch anyone else off guard. Developer/Creator of EVE Marketeer
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 64	Posted - 2012.01.11 20:24:00 - [5] - Quote Hey Dragonaire, I've just taken a look at my yap_accountAccountStatus table, and it's pretty messed up :P is it by any chance possible that a new item is created every time yapeal queries for this information? EMK certainly doesn't have 255.000 accounts... I've now added a primary key on keyID to keep it from doing things like this again, but I do not know if that's entirely correct. In addition, does yapeal EVER clean it's utilXmlCache table? Mine seems to be filling up like there's no tomorrow (15 GB?) Developer/Creator of EVE Marketeer
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 68	Posted - 2012.01.12 21:18:00 - [6] - Quote Well, my problem was that there wasn't 350 items in accountStatus, it was 255000. EMK has (only) 350 keys. The accountstatus table seemed to be missing a PK, meaning the upsert would probaby constantly insert. Problem with xml schema maybe? Developer/Creator of EVE Marketeer
Callean Drevus Icosahedron Crafts and Shipping Silent Infinity 69	Posted - 2012.01.16 07:07:00 - [7] - Quote Yay! Will try out cache cleaner as soon as I get a chance. Not that 15 gb cache is bothering me much, but it's just silly Developer/Creator of EVE Marketeer

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.